Performance Measurement and Tuning of Hot-Standby Databases
نویسندگان
چکیده
General-purpose, high-availability database systems have lately proliferated to various network element platforms. In telecommunication, databases are expected to meet demanding availability levels while preserving the required throughput. However, so far, the effects of various high-availability configurations on overall database performance have not been analyzed. In this paper, the operation of a fully replicated, hot-standby database system is presented, together with some performance tuning possibilities. To study the effect of several database-tuning parameters, a telecom-oriented database benchmark, TM1, is used. The experiments involve varying of the read/write balance and various logging and replication parameters. It is shown that, by relaxing the reliability requirements, significant performance gains can be achieved. Also, it is demonstrated that a possibility to redirect the log writing from the local disk to the standby node is one of the most important benefits of a high-availability database system.
منابع مشابه
Analysis of Stochastic Model on a Two-Unit Hot Standby Combined Hardware-Software System
This paper deals with a stochastic model for a two-unit hot standby combined hardware-software system in which one unit is operative and the other is hot standby. The operative unit may have hardware or software failures and goes to repair. This leads to degradation of the system and then hot standby unit is under operation. Further on hardware or software failures of the hot standby unit the s...
متن کاملAvailability of 3-out-of-4:G Warm Standby System
Standby techniques are used to improve system availability. Usually, a k-out-of-n:G standby system is assumed that when an operating component fails, a standby component becomes active and the system is working if at least k components are fault-free. In general, there are three types in component standby, i.e., cold, hot and warm standby. Cold standby implies that inactive components have a ze...
متن کاملWarm Standby in Hierarchically Structured Process-Control Programs
We classify standby redundancy design space in processcontrol programs into the following three categories: cold standby, warm standby, and hot standby. Design parameters of warm standby are identified and the reliability of a system using warm standby is evaluated and compared with that of hot standby. Our analysis indicates that the warm standby scheme is particularly suitable for long-lived ...
متن کاملPerformance Analysis of a Repairable Robot Safety System with Standby, Imperfect Coverage and Reboot Delay
The present study deals with a robot safety system composed of standby robot units and inbuilt safety unit. When the main operative unit fails, it is replaced by the standby robot unit available in the system. The concept of reboot delay is also incorporated in this study according to which the robot unit is rebooted if it is not successfully recovered. The recovery and reboot times of failed u...
متن کاملPerformance Modeling of Machining System with Mixed Standby Components Balking and Reneging
This paper deals with machine repair problem with balking and reneging. There is provision of mixed standby (warm and cold) components to replace the failed machines. The lifetime and repair time are assumed to have exponential distribution. Birth-death technique is suggested to obtain the queue size distribution in explicit form. A repair facility of C permanent repairmen is facilitated to rep...
متن کامل